/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 127.0.0.1:3307
 Source Schema         : mujianshu

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 30/12/2022 16:46:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `status` tinyint(1) DEFAULT '0' COMMENT '1=可登录',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'admin', '96e79218965eb72c92a549dd5a330112', 1, 1596811829);
INSERT INTO `admin` VALUES (2, 'aaaaaa', '96e79218965eb72c92a549dd5a330112', 1, 1671637539);
INSERT INTO `admin` VALUES (3, '1122334455', '96e79218965eb72c92a549dd5a330112', 1, 1671642974);
COMMIT;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `user_id` int(11) DEFAULT '0' COMMENT '用户ID',
  `read_count` int(11) DEFAULT '0' COMMENT '阅读数',
  `praise_count` int(11) DEFAULT '0' COMMENT '点赞数',
  `comment_count` int(11) DEFAULT '0' COMMENT '评论数',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  `class_id` int(11) DEFAULT '0' COMMENT '所属类型',
  `n_id` int(11) DEFAULT '0' COMMENT '所属文集',
  `status` tinyint(2) DEFAULT '0' COMMENT '0=未发布 1=已发布 2=审核未通过',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for article_class
-- ----------------------------
DROP TABLE IF EXISTS `article_class`;
CREATE TABLE `article_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of article_class
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for notebook
-- ----------------------------
DROP TABLE IF EXISTS `notebook`;
CREATE TABLE `notebook` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0' COMMENT '所属用户',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of notebook
-- ----------------------------
BEGIN;
INSERT INTO `notebook` VALUES (4, 8, '随记', 1670749146);
INSERT INTO `notebook` VALUES (6, 8, '随记2', 1670750765);
INSERT INTO `notebook` VALUES (8, 10, 'PHP', 1670861792);
INSERT INTO `notebook` VALUES (9, 10, 'Go', 1670861800);
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0' COMMENT '接受用户ID',
  `send_user_id` int(11) DEFAULT '0' COMMENT '发送用户ID 0=系统消息',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='通知消息';

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
INSERT INTO `notice` VALUES (1, 8, 0, '【答问卷，赢好礼】 木剑书希望可以听到您的声音！参加问卷调查的前1000位简友还可以获得10个', 1671134446);
INSERT INTO `notice` VALUES (2, 8, 0, '【答问卷，赢好礼】 木剑书希望可以听到您的声音！参加问卷调查的前1000位简友还可以获得10个', 1671134446);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'zhja', 'e10adc3949ba59abbe56e057f20f883e', 1);
INSERT INTO `user` VALUES (8, '18611110000', '96e79218965eb72c92a549dd5a330112', 1670689736);
INSERT INTO `user` VALUES (9, '18600001111', '96e79218965eb72c92a549dd5a330112', 1670858716);
INSERT INTO `user` VALUES (10, '18600001112', '96e79218965eb72c92a549dd5a330112', 1670858788);
INSERT INTO `user` VALUES (11, '18600001113', '96e79218965eb72c92a549dd5a330112', 1670858788);
INSERT INTO `user` VALUES (12, '18600001114', '96e79218965eb72c92a549dd5a330112', 1670858788);
INSERT INTO `user` VALUES (13, '18600001115', '96e79218965eb72c92a549dd5a330112', 1670858788);
INSERT INTO `user` VALUES (14, '18600001116', '96e79218965eb72c92a549dd5a330112', 1670858788);
INSERT INTO `user` VALUES (15, '18600001117', '96e79218965eb72c92a549dd5a330112', 1670858788);
COMMIT;

-- ----------------------------
-- Table structure for user_count
-- ----------------------------
DROP TABLE IF EXISTS `user_count`;
CREATE TABLE `user_count` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `follow` int(255) DEFAULT '0',
  `fans` int(255) DEFAULT '0',
  `article` int(255) DEFAULT '0',
  `add_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user_count
-- ----------------------------
BEGIN;
INSERT INTO `user_count` VALUES (1, 11, 0, 320, 820, 1670689736);
INSERT INTO `user_count` VALUES (2, 12, 0, 200, 60, 1670689736);
INSERT INTO `user_count` VALUES (3, 13, 0, 80, 32, 1670689736);
INSERT INTO `user_count` VALUES (4, 14, 0, 50, 21, 1670689736);
INSERT INTO `user_count` VALUES (5, 15, 0, 500, 1564, 1670689736);
INSERT INTO `user_count` VALUES (6, 10, 0, 0, 0, 1670689736);
INSERT INTO `user_count` VALUES (7, 8, 0, 0, 0, 1670689736);
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0' COMMENT '用户ID',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex` tinyint(2) DEFAULT '0' COMMENT '性别0=保密 1=男 2=女',
  `introduction` varchar(255) DEFAULT NULL COMMENT '简介',
  `homepage` varchar(100) DEFAULT NULL COMMENT '个人主页',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES (2, 8, 'zhja601', '/homestatic/img/avatar.jpeg', 0, '安安定定1', 'aaa1', 1670689736, 1670693145);
INSERT INTO `user_info` VALUES (3, 10, 'zhja600', '/homestatic/img/avatar.jpeg', 0, '下雨le', 'zhja60', 1670858788, 1670859815);
INSERT INTO `user_info` VALUES (4, 11, '木剑卢', '/homestatic/img/tx1.jpeg', 0, NULL, NULL, 1670858788, 1670859815);
INSERT INTO `user_info` VALUES (5, 12, '木剑书小管家', '/homestatic/img/tx2.jpeg', 0, NULL, NULL, 1670858788, 1670858788);
INSERT INTO `user_info` VALUES (6, 13, '木剑吴', '/homestatic/img/tx3.jpeg', 0, NULL, NULL, 1670858788, 1670858788);
INSERT INTO `user_info` VALUES (7, 14, '木剑闫', '/homestatic/img/tx4.jpeg', 0, NULL, NULL, 1670858788, 1670858788);
INSERT INTO `user_info` VALUES (8, 15, '木剑霍比特', '/homestatic/img/tx5.jpeg', 0, NULL, NULL, 1670858788, 1670858788);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
